Skip to main content
Feedback

Creating an initial load

This process uses the new Boomi DataHub connector, which is necessary for every new data source connected to DataHub.The integration starts with a connector like Salesforce, maps the data to the data model in DataHub, and then sends the data into DataHub. With the initial load, you are taking a data source and sending that data into DataHub.

diagram showing an example of an integration that sends contact data from the Salesforce connector, maps it to Hub, and sends the data to the repository using the Update operation.

Prerequisites

Create and deploy a contact model and add a runtime cloud.

Enabling initial load

  1. In Repositories > appropriate repository such Customer > appropriate model such as contact > Sources, there are your sources such as SFDC (source ID). This is set to contribute and accept data. The grey dot means you have not initially loaded data from Salesforce.
  2. Click the gear icon to open the drop-down.
  3. Click Enable Initial Load.

Salesforce Connector Step

  1. To create the integration, open the Integration service and navigate to the Build tab. In the sidebar, click the plus icon. Select Process and click Create.
  2. In the Start Step screen, the first step you need to create is the Salesforce connector. For Display Name, type in an appropriate name like Salesforce. For Connector, select Salesforce connector.
  3. For Connection, select an existing connection or create a connection. In this case, select Sandbox Salesforce Connection. To create a connection, click the plus icon in the connection search bar.
  4. Check the URL is correct. Enter your username in the User Name text box.
  5. Click Click to Set to enter your password in the Password. Your connection password is a combination of your Salesforce password first and second security token. For example, if my Salesforce password is “salesforcepassword” and my security token is “token1234” then my connection password is “salesforcepasswordtoken1234”.
  6. Click Apply. To save the connection, click Save & Close.
note

The connection is your Salesforce credentials. When you enter your credentials once, you can use this connection without having to log in again.

  1. Click Import Operation.
  2. To connect DataHub to Salesforce, search for and select the Sandbox Salesforce Connection and click Next. Next, you want to transfer the contact object. The Object Type is Contact and the Action is Query.
note

These are the details of the API call that are going to pull the contact object from Salesforce.

  1. Click Next. DataHub is pulling all of the fields from the contact object.
  2. Click Next.
  3. Click Finish.
  4. Click Save and Close.

DataHub Connector Step

  1. You need to create the DataHub Connector step. In the search bar, search for Boomi Datahub. In the Connect Step screen for the Connection, click the plus icon.
  2. You can name the connection a name closely related to the repository, such as DataHub Customer Connection.
  3. The Cloud Name is Customer since that is the repository I want to sync in Salesforce with DataHub.
  4. For the Username, go to DataHub, click the appropriate repository, such as Customer, click Configure, and click Copy on the Username. Go back to the Integration service connection tab and paste the Username.
  5. To find which cloud you are on for the Custom URL, go to Repositories > appropriate repository such as Customer > Configure tab, and view the URL in Base URL for API Requests. Copy the URL and paste the URL in the Custom URL field in the following format, appending /mdm to the path: https://<base URL>/mdm/.
  6. To set the token, go to Repositories > appropriate repository such as Customer > Configure tab, click Copy on the My Hub Authentication Token, click Click to Set, past the token, and click Apply.
  7. Click Save.
  8. Go to the New Process tab > Connector Step screen.
  9. To pull and update the golden records from Salesforce to DataHub, click the Action dropdown and select Update Golden Records.
  10. To configure the Operation, click the plus icon in the Operation search bar.
  11. Here, you can rename the Operation, such as Update Contact Operation.
  12. Click Import Operation.
  13. In the Integration service, click the Connector icon to open the Connector Step screen.
  14. Click the edit pencil button to edit the Operation.
  15. Click Import Operation. Click the Runtime dropdown and select Runtime Example. In the Connection dropdown, click DataHub Customer Connection. Click Next.
  16. The runtime is connecting to DataHub to import the DataHub models. Click the contact model. Click Next. DataHub is looking up the data schema for the model to create a structure that includes the fields and structure for updating or creating new golden records.
  17. Click Finish.
  18. Enter your source in the Source field. In the DataHub service, go to Sources and find the appropriate source ID under the Source ID column. Click Save & Close. The DataHub connection is properly configured.

Map Step

  1. In the Connector Step screen, click OK. To map the the Salesforce database to DataHub, you have to create a Map step.
  2. Click and drag the Map step onto the grid.
  3. At this point, drag the “>” to each appropriate step to connect the steps. You need to configure the Map step.
  4. Beneath the Map step, click Configure.
  5. Click the plus icon in the Map search bar. Name the map SF Contact to Hub Contact. In this case, the Map Source is Salesforce.
  6. In the Map Source, click Choose. Click the Profile search bar and find the correct profile, which is SF_Contact_QUERY_Response.
  7. Click OK.
  8. Click the Profile search bar and find the correct profile, which is SF_Contact_QUERY_Response. Click OK.
  9. The contact record fields are populated in the Map Source. The Map Destination is the record that receives the information, which is the model in DataHub.
  10. In the Map Destination, click Choose.
  11. Click the Profile search bar and find the correct profile, which is Boomi DataHub contact updateGoldenRecords Request.
  12. Click OK.
  13. Drag the Salesforce fields to the corresponding DataHub fields. For example, the Salesforce id should be connected to the DataHub id.
  14. Create a Stop step. Click the > icon, search for and select Stop. Click Save.
  15. Click Save & Close.
  16. In the Map Step screen, click OK.
  17. You can test your Integration to check that the process works.
  18. Click Test.
  19. Select the appropriate runtime, which is Runtime Example in this case. Click OK.

For more information on managing records, refer to Stewardship.

On this Page